data new shoes;
set aquarius.shoes_tracker;
if product_category='' then product_category='Shoes';
if supplier_country not in('GB','US') then supplier_country=upcase(supplier_country);
else if supplier_country='UT' then supplier_country='US';
if supplier_name not in('3Top Sports','Greenline Sports Ltd') then supplier_name in('3Top Sports','Greenline Sports Ltd');
if supplier_name='3Top Sports' then supplier_id=2963;
else supplier_id=14682;
run;

proc print data=newshoes;
run;